SyStudentInquiry 
Logical Entity Name  SyStudentInquiry 
Default Table Name  SyStudentInquiry 
Physical Only  NO 
Definition 
 
Note 
 

SyStudentInquiry Columns 
ColumnName  Domain  Datatype  NULL  Definition 
SyStudentInquiryID(PK)    int  NO 
 
SyStudentID    int  NO 
 
SyCampusID(FK)    int  NO 
 
LeadDate    datetime  NO 
 
OriginalAmRepID(FK)    int  YES 
 
AmRepID(FK)    int  YES 
 
AdProgramGroupID(FK)    int  YES 
 
AdProgramID(FK)    int  YES 
 
AmLeadSrcID(FK)    int  YES 
 
AmLeadTypeID(FK)    int  YES 
 
LastActivityDate    datetime  YES 
 
Current    bit  NO 
 
UserID(FK)    int  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
ts    timestamp  NO 
 
AmRepTypeID(FK)    int  YES 
 
AmZoneID    int  YES 
 
ResponsePhone    char(16)  YES 
 
ResponseTime    datetime  YES 
 
ResponseDate    datetime  YES 
 

SyStudentInquiry Primary and Unique Keys 
Key Name  Key Type  Keys 
SyStudentInquiry_SyStudentID_Current_SyStudentInquiryID_U_N_IDX  Index  SyStudentID, Current, SyStudentInquiryID 
SyStudentInquiry_SyStudentInquiryID_U_C_IDX  PrimaryKey  SyStudentInquiryID 

SyStudentInquiry Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdProgramGroup  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_AdProgramGroupID_AdProgram_AdProgramID      AdProgramGroupID  NO  YES 
AdProgram  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_AdProgramID_AdProgram_AdProgramID      AdProgramID  NO  YES 
amLeadSrc  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_AmLeadSrcID_AmLeadSrc_AmLeadSrcID      AmLeadSrcID  NO  YES 
AmLeadType  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_AmLeadTypeID_AmLeadType_AmLeadTypeID      AmLeadTypeID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_AmRepID_SyStaff_SyStaffID      AmRepID  NO  YES 
amRepType  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_AmRepTypeID_AmRepType_AmRepTypeID      AmRepTypeID  NO  YES 
SyStaff  Non-Identifying  Zero or One to Zero or More  FK_SyStudentInquiry_OriginalAmRepID_SyStaff_SyStaffID      OriginalAmRepID  NO  YES 
SyCampus  Non-Identifying  One To Zero or More  FK_SyStudentInquiry_SyCampusID_SyCampus_SyCampusID      SyCampusID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_SyStudentInquiry_UserID_SyStaff_SyStaffID      UserID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
SyStudentInquiryExternalMap  Non-Identifying  One To Zero or More  FK_SyStudentInquiryExternalMap_SyStudentInquiryId_SyStudentInquirySyStudentInquiryId        NO  YES 

SyStudentInquiry Check Constraints 
Check Constraint Name  CheckConstraint